Overview

Dataset statistics

Number of variables34
Number of observations884
Missing cells9597
Missing cells (%)31.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory234.9 KiB
Average record size in memory272.1 B

Variable types

CAT24
NUM8
UNSUPPORTED1
BOOL1

Reproduction

Analysis started2020-06-19 15:17:13.539414
Analysis finished2020-06-19 15:17:38.089458
Duration24.55 seconds
Versionpandas-profiling v2.8.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Warnings

total has constant value "1" Constant
dni has a high cardinality: 858 distinct values High cardinality
area_estudio has a high cardinality: 101 distinct values High cardinality
titulacion has a high cardinality: 125 distinct values High cardinality
institucion_acogida has a high cardinality: 153 distinct values High cardinality
practicas_empresa has a high cardinality: 54 distinct values High cardinality
practicas_beca is highly correlated with practicas_duracion_mesesHigh correlation
practicas_duracion_meses is highly correlated with practicas_becaHigh correlation
institucion_acogida has 57 (6.4%) missing values Missing
estudios_duracion_meses has 57 (6.4%) missing values Missing
estudios_comienzo_mes has 57 (6.4%) missing values Missing
estudios_num_creditos_ects has 57 (6.4%) missing values Missing
estudios_beca has 57 (6.4%) missing values Missing
practicas_pais has 827 (93.6%) missing values Missing
practicas_empresa has 827 (93.6%) missing values Missing
practicas_empresa_tam has 827 (93.6%) missing values Missing
practicas_empresa_tipo has 827 (93.6%) missing values Missing
practicas_duracion_meses has 827 (93.6%) missing values Missing
practicas_comienzo_mes has 827 (93.6%) missing values Missing
practicas_num_creditos_ects has 827 (93.6%) missing values Missing
practicas_beca has 827 (93.6%) missing values Missing
eilc_sms_beca has 877 (99.2%) missing values Missing
eilc_smp_beca has 884 (100.0%) missing values Missing
eilc_sms_duracion has 877 (99.2%) missing values Missing
estudios_pais has 57 (6.4%) missing values Missing
dni is uniformly distributed Uniform
practicas_empresa is uniformly distributed Uniform
id has unique values Unique
eilc_smp_beca is an unsupported type, check if it needs cleaning or further analysis Unsupported

Variables

id
Real number (ℝ≥0)

UNIQUE

Distinct count884
Unique (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2116.859728506787
Minimum663
Maximum3542
Zeros0
Zeros (%)0.0%
Memory size6.9 KiB

Quantile statistics

Minimum663
5-th percentile803.6
Q11331.75
median2117
Q32893.5
95-th percentile3415.85
Maximum3542
Range2879
Interquartile range (IQR)1561.75

Descriptive statistics

Standard deviation868.1467815
Coefficient of variation (CV)0.4101106794
Kurtosis-1.285850559
Mean2116.859729
Median Absolute Deviation (MAD)781.5
Skewness-0.01393240133
Sum1871304
Variance753678.8342
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
204110.1%
 
283010.1%
 
80310.1%
 
284710.1%
 
79810.1%
 
79710.1%
 
284310.1%
 
284210.1%
 
284110.1%
 
283910.1%
 
Other values (874)87498.9%
 
ValueCountFrequency (%) 
66310.1%
 
66410.1%
 
66610.1%
 
66710.1%
 
67010.1%
 
ValueCountFrequency (%) 
354210.1%
 
354110.1%
 
354010.1%
 
353910.1%
 
352710.1%
 

curso
Categorical

Distinct count6
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
2012/2013
189
2010/2011
184
2011/2012
156
2007/2008
124
2009/2010
121
ValueCountFrequency (%) 
2012/201318921.4%
 
2010/201118420.8%
 
2011/201215617.6%
 
2007/200812414.0%
 
2009/201012113.7%
 
2008/200911012.4%
 

Length

Max length9
Median length9
Mean length9
Min length9

dni
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count858
Unique (%)97.1%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
9030fbfbe3f5e88ccdf432098d2de7ed1aa762ec938949dadba143378f554a3f15341603d40d56807c1a2257183f2b3d302c9a718d1067d33fadf4bd146010ee
 
2
86ee3bc0760e9cd7d9115e1d087c21a23fa086bfb73f18eb19c644781fcec10a7d11a32e0807a8c06332be73f593e8299377f3e6c89a3164c8c2875ab75bc9b8
 
2
d638d7e6aa55b464ea74fe2d9000af0701dac7e01c5fc084b1931511eaa5a93912bac9c41fba88c0aabfcb4c022c2922101464118d18cb6b70791bfd0f869e53
 
2
b91ba732a5946a6683416b829bc9197c8449a1eb09f3fb07c4de47a98f6942a0307ef293e9f1ae58a8f26f8dabd50bbd19cce6990ba98804070e93d4f2ce930d
 
2
db55969ba692a78fe04374c1ab85bf5b02536dc66d5b1425b584af7030ca19f9991255850a6f564663b03b53534f97f2039e0bf797aafc94d1b2a1370cd57e51
 
2
Other values (853)
874
ValueCountFrequency (%) 
9030fbfbe3f5e88ccdf432098d2de7ed1aa762ec938949dadba143378f554a3f15341603d40d56807c1a2257183f2b3d302c9a718d1067d33fadf4bd146010ee20.2%
 
86ee3bc0760e9cd7d9115e1d087c21a23fa086bfb73f18eb19c644781fcec10a7d11a32e0807a8c06332be73f593e8299377f3e6c89a3164c8c2875ab75bc9b820.2%
 
d638d7e6aa55b464ea74fe2d9000af0701dac7e01c5fc084b1931511eaa5a93912bac9c41fba88c0aabfcb4c022c2922101464118d18cb6b70791bfd0f869e5320.2%
 
b91ba732a5946a6683416b829bc9197c8449a1eb09f3fb07c4de47a98f6942a0307ef293e9f1ae58a8f26f8dabd50bbd19cce6990ba98804070e93d4f2ce930d20.2%
 
db55969ba692a78fe04374c1ab85bf5b02536dc66d5b1425b584af7030ca19f9991255850a6f564663b03b53534f97f2039e0bf797aafc94d1b2a1370cd57e5120.2%
 
e2883fbf450e9b04015d42fff32c58f776fb90f2ba0069e6072b68c304687067c0a55c17c66d627b0c0da44354af6de6c09d919e8d8d80bf9a5f6caa1e2d553e20.2%
 
7d4e42573668929aba9a15884dcf52d10c2aa16e229c4bac8fd0cd7a2d3a06ee4039ad40e8b9646ee0696c479d84b5251eb748ae810e4d1891e82236eb0ed4e520.2%
 
e3ac05b00f881b1bcb72bbef3a764d106be6bc9cff91b3360ac826a00237752fcd695fe39434c099f107b8982bdba53ca12f2d315eb42d379c2832d6f14013bb20.2%
 
10afd4d695c197e165d0bfed5b2d8e5b6e5fe5ae8d4ac78974dafacca6dbf2e0c1b83c8bc7b58e43db69fe1ecb2b14b4b7311f57f5ce4ec59f28265acd4ca20a20.2%
 
aa961426d562d7c36c2c70b4d272542a3c8ea630af4ee6036d1cd2b61e720f2a39511dd2d807292621d10eef964bffd643f77ce020484bb65e55af2494dc203220.2%
 
Other values (848)86497.7%
 

Length

Max length128
Median length128
Mean length128
Min length128

edad
Real number (ℝ≥0)

Distinct count17
Unique (%)1.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean21.807692307692307
Minimum18
Maximum39
Zeros0
Zeros (%)0.0%
Memory size6.9 KiB

Quantile statistics

Minimum18
5-th percentile19
Q120
median21
Q323
95-th percentile26
Maximum39
Range21
Interquartile range (IQR)3

Descriptive statistics

Standard deviation2.419088794
Coefficient of variation (CV)0.1109282339
Kurtosis5.350932347
Mean21.80769231
Median Absolute Deviation (MAD)1
Skewness1.64364964
Sum19278
Variance5.851990592
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2017419.7%
 
2215617.6%
 
2115217.2%
 
1912414.0%
 
2311112.6%
 
24616.9%
 
25455.1%
 
26212.4%
 
27111.2%
 
2891.0%
 
Other values (7)202.3%
 
ValueCountFrequency (%) 
1830.3%
 
1912414.0%
 
2017419.7%
 
2115217.2%
 
2215617.6%
 
ValueCountFrequency (%) 
3910.1%
 
3610.1%
 
3220.2%
 
3130.3%
 
3050.6%
 

sexo
Categorical

Distinct count2
Unique (%)0.2%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
H
459
M
425
ValueCountFrequency (%) 
H45951.9%
 
M42548.1%
 

Length

Max length1
Median length1
Mean length1
Min length1

nacionalidad
Categorical

Distinct count2
Unique (%)0.2%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
ES
883
RO
 
1
ValueCountFrequency (%) 
ES88399.9%
 
RO10.1%
 

Length

Max length2
Median length2
Mean length2
Min length2

area_estudio
Categorical

HIGH CARDINALITY

Distinct count101
Unique (%)11.4%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
34 - Administración de empresas
 
117
222 - Idiomas y Filología
 
54
813 - Deportes
 
42
1 - Educación
 
42
32 - Periodismo e información
 
35
Other values (96)
594
ValueCountFrequency (%) 
34 - Administración de empresas11713.2%
 
222 - Idiomas y Filología546.1%
 
813 - Deportes424.8%
 
1 - Educación424.8%
 
32 - Periodismo e información354.0%
 
340 - Administración de empresas (programas generales)273.1%
 
144 - Formación del profesorado de niveles básicos252.8%
 
38 - Derecho222.5%
 
481 - Informática212.4%
 
421 - Biología y bioquímica202.3%
 
Other values (91)47954.2%
 

Length

Max length98
Median length29
Mean length29.41742081
Min length3

titulacion
Categorical

HIGH CARDINALITY

Distinct count125
Unique (%)14.1%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
LICENCIADO EN ADMINISTRACION Y DIRECCION DE EMPRESAS
 
68
GRADUADO O GRADUADA EN ADMINISTRACION Y DIRECCION DE EMPRESAS
 
46
LICENCIADO EN CIENCIAS DE LA ACTIVIDAD FISICA Y DEL DEPORTE
 
45
DIPLOMADO EN CIENCIAS EMPRESARIALES
 
42
GRADUADO O GRADUADA EN EDUCACION PRIMARIA
 
40
Other values (120)
643
ValueCountFrequency (%) 
LICENCIADO EN ADMINISTRACION Y DIRECCION DE EMPRESAS687.7%
 
GRADUADO O GRADUADA EN ADMINISTRACION Y DIRECCION DE EMPRESAS465.2%
 
LICENCIADO EN CIENCIAS DE LA ACTIVIDAD FISICA Y DEL DEPORTE455.1%
 
DIPLOMADO EN CIENCIAS EMPRESARIALES424.8%
 
GRADUADO O GRADUADA EN EDUCACION PRIMARIA404.5%
 
INGENIERO INDUSTRIAL354.0%
 
INGENIERO AGRONOMO273.1%
 
GRADUADO O GRADUADA EN ESTUDIOS INGLESES262.9%
 
LICENCIADO EN COMUNICACION AUDIOVISUAL242.7%
 
LICENCIADO EN FILOLOGIA INGLESA232.6%
 
Other values (115)50857.5%
 

Length

Max length107
Median length40
Mean length40.75904977
Min length7

nivel_estudio
Categorical

Distinct count6
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
1L - Licenciatura
329
1G - Grado
270
1D - Diplomatura
152
S - Short Cycle (ciclo FP grado Superior)
77
F
 
47
ValueCountFrequency (%) 
1L - Licenciatura32937.2%
 
1G - Grado27030.5%
 
1D - Diplomatura15217.2%
 
S - Short Cycle (ciclo FP grado Superior)778.7%
 
F475.3%
 
2 - Second Cycle (Master)91.0%
 

Length

Max length41
Median length16
Mean length16.01131222
Min length1

anos_estudio_previo_erasmus
Real number (ℝ≥0)

Distinct count10
Unique (%)1.1%
Missing1
Missing (%)0.1%
Infinite0
Infinite (%)0.0%
Mean3.2842582106455267
Minimum1.0
Maximum10.0
Zeros0
Zeros (%)0.0%
Memory size6.9 KiB

Quantile statistics

Minimum1
5-th percentile1
Q12
median3
Q34
95-th percentile6
Maximum10
Range9
Interquartile range (IQR)2

Descriptive statistics

Standard deviation1.514724101
Coefficient of variation (CV)0.4612073729
Kurtosis1.587638373
Mean3.284258211
Median Absolute Deviation (MAD)1
Skewness1.01591383
Sum2900
Variance2.294389103
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
324727.9%
 
223927.0%
 
416819.0%
 
59610.9%
 
1647.2%
 
6424.8%
 
7121.4%
 
880.9%
 
950.6%
 
1020.2%
 
(Missing)10.1%
 
ValueCountFrequency (%) 
1647.2%
 
223927.0%
 
324727.9%
 
416819.0%
 
59610.9%
 
ValueCountFrequency (%) 
1020.2%
 
950.6%
 
880.9%
 
7121.4%
 
6424.8%
 

tipo_movilidad
Categorical

Distinct count2
Unique (%)0.2%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
Estudios
827
Prácticas
 
57
ValueCountFrequency (%) 
Estudios82793.6%
 
Prácticas576.4%
 

Length

Max length9
Median length8
Mean length8.064479638
Min length8

institucion_acogida
Categorical

HIGH CARDINALITY
MISSING

Distinct count153
Unique (%)18.5%
Missing57
Missing (%)6.4%
Memory size6.9 KiB
I PARMA01 - UNIVERSITA' DEGLI STUDI DI PARMA
 
45
UK PAISLEY01 - UNIVERSITY OF THE WEST OF SCOTLAND
 
43
UK CARDIFF01 - CARDIFF UNIVERSITY
 
22
I SALERNO01 - UNIVERSITA' DEGLI STUDI DI SALERNO
 
22
DK RISSKOV06 - VIA UNIVERSITY COLLEGE
 
20
Other values (148)
675
ValueCountFrequency (%) 
I PARMA01 - UNIVERSITA' DEGLI STUDI DI PARMA455.1%
 
UK PAISLEY01 - UNIVERSITY OF THE WEST OF SCOTLAND434.9%
 
UK CARDIFF01 - CARDIFF UNIVERSITY222.5%
 
I SALERNO01 - UNIVERSITA' DEGLI STUDI DI SALERNO 222.5%
 
DK RISSKOV06 - VIA UNIVERSITY COLLEGE202.3%
 
P FARO02 - UNIVERSIDADE DO ALGARVE 192.1%
 
P AVEIRO01 - UNIVERSIDADE DE AVEIRO192.1%
 
I BOLOGNA01 - UNIVERSITÀ DI BOLOGNA - ALMA MATER STUDIORUM192.1%
 
P COVILHA01 - UNIVERSIDADE DA BEIRA INTERIOR 161.8%
 
P GUARDA01 - INSTITUTO POLITÉCNICO DA GUARDA161.8%
 
Other values (143)58666.3%
 
(Missing)576.4%
 

Length

Max length87
Median length44
Mean length42.2239819
Min length3

estudios_duracion_meses
Real number (ℝ≥0)

MISSING

Distinct count21
Unique (%)2.5%
Missing57
Missing (%)6.4%
Infinite0
Infinite (%)0.0%
Mean9.069830713422007
Minimum3.0
Maximum11.25
Zeros0
Zeros (%)0.0%
Memory size6.9 KiB

Quantile statistics

Minimum3
5-th percentile8
Q19
median9
Q310
95-th percentile10
Maximum11.25
Range8.25
Interquartile range (IQR)1

Descriptive statistics

Standard deviation1.067716202
Coefficient of variation (CV)0.1177217344
Kurtosis11.69890572
Mean9.069830713
Median Absolute Deviation (MAD)0
Skewness-3.019542381
Sum7500.75
Variance1.140017889
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
946652.7%
 
1021123.9%
 
9.75212.4%
 
9.5202.3%
 
8171.9%
 
8.75171.9%
 
8.5141.6%
 
6111.2%
 
8.2591.0%
 
491.0%
 
Other values (11)323.6%
 
(Missing)576.4%
 
ValueCountFrequency (%) 
330.3%
 
491.0%
 
4.2520.2%
 
4.7550.6%
 
540.5%
 
ValueCountFrequency (%) 
11.2510.1%
 
1110.1%
 
10.7520.2%
 
10.510.1%
 
1021123.9%
 

estudios_comienzo_mes
Categorical

MISSING

Distinct count5
Unique (%)0.6%
Missing57
Missing (%)6.4%
Memory size6.9 KiB
09 - Septiembre
468
10 - Octubre
320
08 - Agosto
 
25
01 - Enero
 
10
02 - Febrero
 
4
ValueCountFrequency (%) 
09 - Septiembre46852.9%
 
10 - Octubre32036.2%
 
08 - Agosto252.8%
 
01 - Enero101.1%
 
02 - Febrero40.5%
 
(Missing)576.4%
 

Length

Max length15
Median length15
Mean length12.95701357
Min length3

estudios_num_creditos_ects
Categorical

MISSING

Distinct count3
Unique (%)0.4%
Missing57
Missing (%)6.4%
Memory size6.9 KiB
60
793
30
 
29
20
 
5
ValueCountFrequency (%) 
6079389.7%
 
30293.3%
 
2050.6%
 
(Missing)576.4%
 

Length

Max length4
Median length4
Mean length3.935520362
Min length3

estudios_beca
Real number (ℝ≥0)

MISSING

Distinct count60
Unique (%)7.3%
Missing57
Missing (%)6.4%
Infinite0
Infinite (%)0.0%
Mean1243.6545973397822
Minimum333.0
Maximum2064.86
Zeros0
Zeros (%)0.0%
Memory size6.9 KiB

Quantile statistics

Minimum333
5-th percentile915.75
Q11080
median1235
Q31423.296
95-th percentile1655.87
Maximum2064.86
Range1731.86
Interquartile range (IQR)343.296

Descriptive statistics

Standard deviation258.131784
Coefficient of variation (CV)0.2075590639
Kurtosis0.4891364668
Mean1243.654597
Median Absolute Deviation (MAD)155
Skewness0.04766239041
Sum1028502.352
Variance66632.0179
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
108012213.8%
 
999859.6%
 
1245.6809.0%
 
1655.87738.3%
 
1581.44536.0%
 
1423.296536.0%
 
1170505.7%
 
1300495.5%
 
1200394.4%
 
1384262.9%
 
Other values (50)19722.3%
 
(Missing)576.4%
 
ValueCountFrequency (%) 
33310.1%
 
36010.1%
 
39010.1%
 
44410.1%
 
52010.1%
 
ValueCountFrequency (%) 
2064.8610.1%
 
1880.8710.1%
 
1839.86151.7%
 
1747.8750.6%
 
1655.87738.3%
 

practicas_pais
Categorical

MISSING

Distinct count13
Unique (%)22.8%
Missing827
Missing (%)93.6%
Memory size6.9 KiB
PT - Portugal
22
IT - Italy
8
IE - Ireland
7
UK - United Kingdom
7
NO - Norway
 
3
Other values (8)
10
ValueCountFrequency (%) 
PT - Portugal222.5%
 
IT - Italy80.9%
 
IE - Ireland70.8%
 
UK - United Kingdom70.8%
 
NO - Norway30.3%
 
GR - Greece20.2%
 
DE - Germany20.2%
 
TR - Turkey10.1%
 
SI - Slovenia10.1%
 
LT - Lithuania10.1%
 
Other values (3)30.3%
 
(Missing)82793.6%
 

Length

Max length19
Median length3
Mean length3.642533937
Min length3

practicas_empresa
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct count54
Unique (%)94.7%
Missing827
Missing (%)93.6%
Memory size6.9 KiB
BERGEN KOMMUNE
 
3
LABORATORIO DE ANALISSES QUIMICAS
 
2
CASTLEROY COLLEGE
 
1
LATIN AMERICAN DISABLE PEOPLE'S PROJECT
 
1
APPROVEITAMENTOS GANADEIROS 2009 IDA
 
1
Other values (49)
49
ValueCountFrequency (%) 
BERGEN KOMMUNE30.3%
 
LABORATORIO DE ANALISSES QUIMICAS20.2%
 
CASTLEROY COLLEGE10.1%
 
LATIN AMERICAN DISABLE PEOPLE'S PROJECT10.1%
 
APPROVEITAMENTOS GANADEIROS 2009 IDA10.1%
 
CONVENTO DO ESPINHEIRO10.1%
 
U.DO PORTO - SERVICE OF COMMUNICATION.10.1%
 
MADEOFMAN10.1%
 
MUSEU MONOGRAFICO DE CONIMBRIGA10.1%
 
ANTI RIZIKO10.1%
 
Other values (44)445.0%
 
(Missing)82793.6%
 

Length

Max length102
Median length3
Mean length4.823529412
Min length3

practicas_empresa_tam
Categorical

MISSING

Distinct count3
Unique (%)5.3%
Missing827
Missing (%)93.6%
Memory size6.9 KiB
M (51-250)
25
S (<50)
18
L (>250)
14
ValueCountFrequency (%) 
M (51-250)252.8%
 
S (<50)182.0%
 
L (>250)141.6%
 
(Missing)82793.6%
 

Length

Max length10
Median length3
Mean length3.358597285
Min length3

practicas_empresa_tipo
Categorical

MISSING

Distinct count10
Unique (%)17.5%
Missing827
Missing (%)93.6%
Memory size6.9 KiB
P - Education
19
S - Other Service Activities
14
M - Professional, Scientific And Technical Activities
5
I - Accommodation And Food Service Activities
4
A - Agriculture, Forestry And Fishing
4
Other values (5)
11
ValueCountFrequency (%) 
P - Education192.1%
 
S - Other Service Activities141.6%
 
M - Professional, Scientific And Technical Activities50.6%
 
I - Accommodation And Food Service Activities40.5%
 
A - Agriculture, Forestry And Fishing40.5%
 
J - Information And Communication40.5%
 
R - Arts, Entertainment And Recreation30.3%
 
O - Public Administration And Defence; Compulsory Social Security20.2%
 
U - Activities Of Extraterritorial Organizations And Bodies10.1%
 
K - Financial And Insurance Activities10.1%
 
(Missing)82793.6%
 

Length

Max length65
Median length3
Mean length4.735294118
Min length3

practicas_duracion_meses
Real number (ℝ≥0)

HIGH CORRELATION
MISSING

Distinct count9
Unique (%)15.8%
Missing827
Missing (%)93.6%
Infinite0
Infinite (%)0.0%
Mean5.412280701754386
Minimum3.0
Maximum10.0
Zeros0
Zeros (%)0.0%
Memory size6.9 KiB

Quantile statistics

Minimum3
5-th percentile3
Q13
median5
Q37
95-th percentile9.2
Maximum10
Range7
Interquartile range (IQR)4

Descriptive statistics

Standard deviation2.418534841
Coefficient of variation (CV)0.4468605703
Kurtosis-1.172075906
Mean5.412280702
Median Absolute Deviation (MAD)2
Skewness0.5055964965
Sum308.5
Variance5.849310777
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
3212.4%
 
680.9%
 
970.8%
 
550.6%
 
740.5%
 
840.5%
 
440.5%
 
1030.3%
 
3.510.1%
 
(Missing)82793.6%
 
ValueCountFrequency (%) 
3212.4%
 
3.510.1%
 
440.5%
 
550.6%
 
680.9%
 
ValueCountFrequency (%) 
1030.3%
 
970.8%
 
840.5%
 
740.5%
 
680.9%
 

practicas_comienzo_mes
Categorical

MISSING

Distinct count11
Unique (%)19.3%
Missing827
Missing (%)93.6%
Memory size6.9 KiB
10 - Octubre
11
07 - Julio
10
09 - Septiembre
8
02 - Febrero
7
11 - Noviembre
5
Other values (6)
16
ValueCountFrequency (%) 
10 - Octubre111.2%
 
07 - Julio101.1%
 
09 - Septiembre80.9%
 
02 - Febrero70.8%
 
11 - Noviembre50.6%
 
03 - Marzo50.6%
 
06 - Junio30.3%
 
04 - Abril30.3%
 
08 - Agosto30.3%
 
01 - Enero10.1%
 
(Missing)82793.6%
 

Length

Max length15
Median length3
Mean length3.567873303
Min length3

practicas_num_creditos_ects
Real number (ℝ≥0)

MISSING

Distinct count11
Unique (%)19.3%
Missing827
Missing (%)93.6%
Infinite0
Infinite (%)0.0%
Mean21.596491228070175
Minimum10.0
Maximum60.0
Zeros0
Zeros (%)0.0%
Memory size6.9 KiB

Quantile statistics

Minimum10
5-th percentile10
Q115
median16
Q330
95-th percentile41
Maximum60
Range50
Interquartile range (IQR)15

Descriptive statistics

Standard deviation11.9490879
Coefficient of variation (CV)0.553288392
Kurtosis2.172829183
Mean21.59649123
Median Absolute Deviation (MAD)4
Skewness1.530436825
Sum1231
Variance142.7807018
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
15161.8%
 
1091.0%
 
2091.0%
 
3080.9%
 
4050.6%
 
1630.3%
 
6020.2%
 
1220.2%
 
4510.1%
 
1810.1%
 
(Missing)82793.6%
 
ValueCountFrequency (%) 
1091.0%
 
1220.2%
 
15161.8%
 
1630.3%
 
1810.1%
 
ValueCountFrequency (%) 
6020.2%
 
4510.1%
 
4050.6%
 
3080.9%
 
2610.1%
 

practicas_beca
Real number (ℝ≥0)

HIGH CORRELATION
MISSING

Distinct count28
Unique (%)49.1%
Missing827
Missing (%)93.6%
Infinite0
Infinite (%)0.0%
Mean1826.7136842105263
Minimum870.0
Maximum4012.4
Zeros0
Zeros (%)0.0%
Memory size6.9 KiB

Quantile statistics

Minimum870
5-th percentile870
Q1900
median1500
Q32880
95-th percentile3457.806
Maximum4012.4
Range3142.4
Interquartile range (IQR)1980

Descriptive statistics

Standard deviation955.5405572
Coefficient of variation (CV)0.5230926803
Kurtosis-0.986918367
Mean1826.713684
Median Absolute Deviation (MAD)630
Skewness0.6199300958
Sum104122.68
Variance913057.7564
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
870111.2%
 
90070.8%
 
288050.6%
 
192050.6%
 
150030.3%
 
120020.2%
 
3166.320.2%
 
324020.2%
 
224010.1%
 
174010.1%
 
Other values (18)182.0%
 
(Missing)82793.6%
 
ValueCountFrequency (%) 
870111.2%
 
90070.8%
 
96010.1%
 
105010.1%
 
108010.1%
 
ValueCountFrequency (%) 
4012.410.1%
 
3589.3510.1%
 
3589.0310.1%
 
342510.1%
 
324020.2%
 
Distinct count2
Unique (%)0.2%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
S
761
N
 
123
ValueCountFrequency (%) 
S76186.1%
 
N12313.9%
 

Length

Max length1
Median length1
Mean length1
Min length1
Distinct count11
Unique (%)1.2%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
PT
288
EN
250
IT
214
FR
60
DE
 
44
Other values (6)
 
28
ValueCountFrequency (%) 
PT28832.6%
 
EN25028.3%
 
IT21424.2%
 
FR606.8%
 
DE445.0%
 
GB232.6%
 
CZ10.1%
 
GR10.1%
 
EL10.1%
 
PL10.1%
 

Length

Max length2
Median length2
Mean length2
Min length2
Distinct count3
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
N
861
S
 
22
P
 
1
ValueCountFrequency (%) 
N86197.4%
 
S222.5%
 
P10.1%
 

Length

Max length1
Median length1
Mean length1
Min length1
Distinct count3
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
N
709
O
156
D
 
19
ValueCountFrequency (%) 
N70980.2%
 
O15617.6%
 
D192.1%
 

Length

Max length1
Median length1
Mean length1
Min length1

eilc_sms_beca
Categorical

MISSING

Distinct count3
Unique (%)42.9%
Missing877
Missing (%)99.2%
Memory size6.9 KiB
225
5
375
 
1
300
 
1
ValueCountFrequency (%) 
22550.6%
 
37510.1%
 
30010.1%
 
(Missing)87799.2%
 

Length

Max length5
Median length3
Mean length3.015837104
Min length3

eilc_smp_beca
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing884
Missing (%)100.0%
Memory size7.0 KiB

eilc_sms_duracion
Categorical

MISSING

Distinct count3
Unique (%)42.9%
Missing877
Missing (%)99.2%
Memory size6.9 KiB
0,75
5
1
 
1
1,25
 
1
ValueCountFrequency (%) 
0,7550.6%
 
110.1%
 
1,2510.1%
 
(Missing)87799.2%
 

Length

Max length4
Median length3
Mean length3.004524887
Min length1

estudios_pais
Categorical

MISSING

Distinct count23
Unique (%)2.8%
Missing57
Missing (%)6.4%
Memory size6.9 KiB
PT - Portugal
266
IT - Italy
206
UK - United Kingdom
104
FR - France
 
52
DE - Germany
 
39
Other values (18)
160
ValueCountFrequency (%) 
PT - Portugal26630.1%
 
IT - Italy20623.3%
 
UK - United Kingdom10411.8%
 
FR - France525.9%
 
DE - Germany394.4%
 
DK - Denmark232.6%
 
IE - Ireland222.5%
 
PL - Poland222.5%
 
FI - Finland111.2%
 
NO - Norway101.1%
 
Other values (13)728.1%
 
(Missing)576.4%
 

Length

Max length19
Median length12
Mean length12.13800905
Min length3

pais_destino
Categorical

Distinct count23
Unique (%)2.6%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
PT - Portugal
288
IT - Italy
214
UK - United Kingdom
111
FR - France
 
52
DE - Germany
 
41
Other values (18)
178
ValueCountFrequency (%) 
PT - Portugal28832.6%
 
IT - Italy21424.2%
 
UK - United Kingdom11112.6%
 
FR - France525.9%
 
DE - Germany414.6%
 
IE - Ireland293.3%
 
PL - Poland232.6%
 
DK - Denmark232.6%
 
NO - Norway131.5%
 
GR - Greece121.4%
 
Other values (13)788.8%
 

Length

Max length19
Median length12
Mean length12.78054299
Min length10

total
Boolean

CONSTANT
REJECTED

Distinct count1
Unique (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
1
884
ValueCountFrequency (%) 
1884100.0%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Missing values

Sample

First rows

idcursodniedadsexonacionalidadarea_estudiotitulacionnivel_estudioanos_estudio_previo_erasmustipo_movilidadinstitucion_acogidaestudios_duracion_mesesestudios_comienzo_mesestudios_num_creditos_ectsestudios_becapracticas_paispracticas_empresapracticas_empresa_tampracticas_empresa_tipopracticas_duracion_mesespracticas_comienzo_mespracticas_num_creditos_ectspracticas_becaaprendizaje_idioma_anfitrionidioma_de_formacion_recibidaparticipacion_previa_erasmuscualificacion_obtenida_en_pais_acogidaeilc_sms_becaeilc_smp_becaeilc_sms_duracionestudios_paispais_destinototal
012712008/20092a35e7f13bdc6ea7a04b251463adceb86ca3d77d57dc231c06ed1ed96923786c04f2b3129dd05bc17bc68e2079237be8920ba3d28277f739f952dc9d67ba4e6522HES723 - Enfermería, obstetricia y fisioterapiaDIPLOMADO EN ENFERMERIA1D - Diplomatura2.0EstudiosI FIRENZE01 - UNIVERSITA' DEGLI STUDI DI FIRENZE9.010 - Octubre60.01655.87NaNNaNNaNNaNNaNNaNNaNNaNSITNNNaNNaNNaNIT - ItalyIT - Italy1
119932010/2011491fc9b9628d9f43fb1e27960707dcb0ed7bbd3b3e066a18df72240f4485726371f4826a9cd2464bc260667a53a7d0e874f8e1dc2b28322339bfaa031248fde820HES6 - Agricultura y veterinariaINGENIERO AGRONOMO1L - Licenciatura3.0EstudiosP BEJA01 - INSTITUTO POLITÉCNICO DE BEJA9.010 - Octubre60.01080.00NaNNaNNaNNaNNaNNaNNaNNaNSPTNNNaNNaNNaNPT - PortugalPT - Portugal1
224892011/20127ba6ff8737892c3c68870ff9dd6fa626866a9ab97ca32695772bcd6e82998ef87f28c7a2823f0b4dc029f0b2990e5aa25866a3ab3e57aa8809c992ce26ca50d921MES524 - Química y procesosINGENIERO QUIMICO1L - Licenciatura4.0EstudiosI BOLOGNA01 - UNIVERSITÀ DI BOLOGNA - ALMA MATER STUDIORUM10.009 - Septiembre60.01110.00NaNNaNNaNNaNNaNNaNNaNNaNSITNONaNNaNNaNIT - ItalyIT - Italy1
313822009/2010ed88535b7d9c133936ac4f096578eaf10d9b64a3cfc11888307331fa0d42efb5d8bb32cfc34e4cbe8815700650daf380cc997cc6007048c41635e0ace6b4040220MES314 - EconomíaLICENCIADO EN ECONOMIA1L - Licenciatura3.0EstudiosI PARMA01 - UNIVERSITA' DEGLI STUDI DI PARMA9.009 - Septiembre60.01245.60NaNNaNNaNNaNNaNNaNNaNNaNSITNNNaNNaNNaNIT - ItalyIT - Italy1
412532008/200964bed883fa25ed89bd7b810be60ca5f3f6559700f475fdcc09797fd7fdd50014e9715cccc98b730f96ff3578437e45d731776eccdbee86d930ef54f0e1843d3c20MES21 - ArtesLICENCIADO EN HISTORIA DEL ARTE1L - Licenciatura3.0EstudiosI NAPOLI02 - UNIVERSITA' DEGLI STUDI DI NAPOLI L'ORIENTALE9.010 - Octubre60.01655.87NaNNaNNaNNaNNaNNaNNaNNaNSITNNNaNNaNNaNIT - ItalyIT - Italy1
524832011/2012093a76112667273d750ea9a33092fae60d054cc5c19d820c425ceb5386a157b8f328d386062f59b362aea004ad46ae330b69ebb105fe925aa521f1feb269d8ef20HES222 - Idiomas y FilologíaLICENCIADO EN FILOLOGIA HISPANICA1L - Licenciatura3.0EstudiosI TRIESTE01 - UNIVERSITA' DEGLI STUDI DI TRIESTE9.010 - Octubre60.0999.00NaNNaNNaNNaNNaNNaNNaNNaNSITNONaNNaNNaNIT - ItalyIT - Italy1
634262012/2013098f54ffb4d29b68d1a1c79b733d8fa00d01e2534cb77683f28abb026660abe7ae2ecd1e63b53e3c726fe263324327aea95b18f206593fa22b3d9ae25af6f6c919HES144 - Formación del profesorado de niveles básicosGRADUADO O GRADUADA EN EDUCACION PRIMARIA1G - Grado2.0EstudiosD WEINGAR01 - PAEDAGOGISCHE HOCHSCHULE WEINGARTEN10.009 - Septiembre30.01300.00NaNNaNNaNNaNNaNNaNNaNNaNSDENNNaNNaNNaNDE - GermanyDE - Germany1
730802012/20130b3543e8af9d4d1d8d1aa0fb7dd260c96fec2cc6569d9ef0d2aaf8e1a012d0e84705123ea49a2dad8f00dc3434560df60838d3d984e51ba3067c202722517aaa28HES34 - Administración de empresasGRADUADO O GRADUADA EN ADMINISTRACION Y DIRECCION DE EMPRESAS1G - Grado2.0EstudiosI SALERNO01 - UNIVERSITA' DEGLI STUDI DI SALERNO8.009 - Septiembre60.01040.00NaNNaNNaNNaNNaNNaNNaNNaNSITNNNaNNaNNaNIT - ItalyIT - Italy1
815212009/201003f5ade3d0d558cc3c65c9e8f0cd1a26a4f0b0bfd062d521cf45d63e2b72943718aa6d0837ef752af0b35673d5406ab5a91be2fb51c6e343cae740d7fe28343322HES34 - Administración de empresasLICENCIADO EN ADMINISTRACION Y DIRECCION DE EMPRESAS1L - Licenciatura1.0EstudiosPL LODZ15 - WYZSZA SZKOLA STUDIÓW MIÊDZYNARODOWYCH9.009 - Septiembre60.01245.60NaNNaNNaNNaNNaNNaNNaNNaNNENNNNaNNaNNaNPL - PolandPL - Poland1
914552009/20100b3b0f798f74b059cfe442ad5984b27e5d4f5090040990cb45989e513073857062f10cc204490160ecaa59ce3423e98e618ac78e53c84416e685f7d6ad10d11a19HES38 - DerechoLICENCIADO EN DERECHO1L - Licenciatura2.0EstudiosCZ PRAHA07 - UNIVERZITA KARLOVA V PRAZE10.009 - Septiembre60.01384.00NaNNaNNaNNaNNaNNaNNaNNaNNENNNNaNNaNNaNCZ - Czech RepublicCZ - Czech Republic1

Last rows

idcursodniedadsexonacionalidadarea_estudiotitulacionnivel_estudioanos_estudio_previo_erasmustipo_movilidadinstitucion_acogidaestudios_duracion_mesesestudios_comienzo_mesestudios_num_creditos_ectsestudios_becapracticas_paispracticas_empresapracticas_empresa_tampracticas_empresa_tipopracticas_duracion_mesespracticas_comienzo_mespracticas_num_creditos_ectspracticas_becaaprendizaje_idioma_anfitrionidioma_de_formacion_recibidaparticipacion_previa_erasmuscualificacion_obtenida_en_pais_acogidaeilc_sms_becaeilc_smp_becaeilc_sms_duracionestudios_paispais_destinototal
87432012012/201349c1af17416d6bd6d10388dfaf2bf8e6f1829fd0faaa07704b1746b01f0d252400a7eb01d0b640df9634025df6be4a28b3947b99aa27031fe8602da7be710f8223HES721 - MedicinaLICENCIADO EN MEDICINA1L - Licenciatura4.0EstudiosI BARI01 - UNIVERSITA' DEGLI STUDI DI BARI8.7510 - Octubre60.01137.500NaNNaNNaNNaNNaNNaNNaNNaNSITNNNaNNaNNaNIT - ItalyIT - Italy1
87519772010/2011a79b8a07278c5dec28cc5a43a88e61ba7824412b7bac8cd31ae8294f411a186ddd141f020016c60e29ad7cd698ac847d46e55458f7b46061a463ecc150865a9822HES481 - InformáticaINGENIERO INFORMATICO1L - Licenciatura4.0EstudiosP COIMBRA01 - UNIVERSIDADE DE COIMBRA9.0010 - Octubre60.01080.000NaNNaNNaNNaNNaNNaNNaNNaNSPTNNNaNNaNNaNPT - PortugalPT - Portugal1
87631082012/20136dfe9bae5632d2b043fe31902ec4bb79350cdcb2d573eea194d6121f5391ff8ddb7b3a8d61d5bf8c8ba31ec8abe466955fc2bb5771febdd31292e26bc397349319MES143 - Formación para maestros de preescolarGRADUADO O GRADUADA EN EDUCACION INFANTIL1G - Grado2.0EstudiosSF KUOPIO12 - ITÄ-SUOMEN YLIOPISTO9.0009 - Septiembre60.01170.000NaNNaNNaNNaNNaNNaNNaNNaNNENNNNaNNaNNaNFI - FinlandFI - Finland1
8778602007/200899fa7563c78344843308e08ddb8a4006e6877488398557bd923ec1e3f02f004c73070adbf1f897b39d72756e7b2ce555d0ba022e88e3a197221ec83aa7cd421522MES04.0 - Ciencias empresarialesDIPLOMADO EN CIENCIAS EMPRESARIALESF3.0EstudiosP AVEIRO01 - UNIVERSIDADE DE AVEIRO9.0010 - Octubre60.01423.296NaNNaNNaNNaNNaNNaNNaNNaNSPTNNNaNNaNNaNPT - PortugalPT - Portugal1
87820732010/20110a39de2f27749245c7886720a30342fdad00d6dd38eef0a333ceecac4ed78de08076f73c198716396e7be4ee774dcd5d7a2d53f38393691f2cc0dbf96c472b8623HES34 - Administración de empresasGRADUADO O GRADUADA EN ADMINISTRACION Y DIRECCION DE EMPRESAS1G - Grado3.0EstudiosLT VILNIUS01 - VILNIAUS UNIVERSITETAS10.0009 - Septiembre60.01200.000NaNNaNNaNNaNNaNNaNNaNNaNNENNNNaNNaNNaNLT - LithuaniaLT - Lithuania1
87928932011/2012079914bcb214c452193cda9632a5f73ac388776984d510375672f5cf20612c105af746ea37123fa7601b8f05ae8eb1e7a7136e1a3b80c7d5845799cc1d6b2bee19HES640 - VeterinariaLICENCIADO EN VETERINARIA1L - Licenciatura6.0EstudiosRO CLUJNAP04 - UNIVERSITATEA DE STIINTE AGRICOLE SI MEDICINA VETERINARA DIN CLUJ-NAPOCA9.0010 - Octubre60.0999.000NaNNaNNaNNaNNaNNaNNaNNaNNENNONaNNaNNaNRO - RomaniaRO - Romania1
88030932012/2013079f249645b13e745cecfb0f0c66c6393f9c5054dc650ea3a51eb693a5a46c5057b8d5a3a5d85905d54cb5f51e67c78eb2376c737998dd6fa0b96ca11d9452ed19HES34 - Administración de empresasGRADUADO O GRADUADA EN ADMINISTRACION Y DIRECCION DE EMPRESAS1G - Grado2.0EstudiosSF TURKU05 - TURUN AMMATTIKORKEAKOULU - ÅBO YRKESHÖGSKOLA8.2509 - Septiembre60.01072.500NaNNaNNaNNaNNaNNaNNaNNaNNENNNNaNNaNNaNFI - FinlandFI - Finland1
88120532010/20115e78877fce981f9f289503295e009c457adcf4dfe10dd8d19ab4dfa0e4758bda536776b599b06fe57129d99281950361da63b329545a83e84b7f8ae4ee35499322HES721 - MedicinaLICENCIADO EN MEDICINA1L - Licenciatura5.0EstudiosHU DEBRECE01 - DEBRECENI EGYETEM10.0009 - Septiembre60.01200.000NaNNaNNaNNaNNaNNaNNaNNaNNENNNNaNNaNNaNHU - HungaryHU - Hungary1
88229202011/2012c2db7ad0e5a2f656fb873a8294d541f7c3e8b5f26f488d2ea782e04aa2f48d2eb85af4fa547620aa0804e2a98908e1f246f08defb4349f735a347c69a698e98719MES1 - EducaciónGRADUADO O GRADUADA EN EDUCACION PRIMARIA1G - Grado2.0EstudiosP PORTO02 - Universidade do Porto9.0009 - Septiembre60.0999.000NaNNaNNaNNaNNaNNaNNaNNaNSPTNONaNNaNNaNPT - PortugalPT - Portugal1
88319252010/2011f63b0fa5a9333e3a72036c11d4c75c5b937197d41edfd290747041d735869dd87af73c3453c52532cfbc8a15ae12b3cdba0c10ba5662b117c12141b41e5112e320MES1 - EducaciónMAESTRO ESP. EDUCACION MUSICAL1D - Diplomatura3.0EstudiosD MARBURG01 - PHILIPPS-UNIVERSITAET MARBURG10.0009 - Septiembre60.01200.000NaNNaNNaNNaNNaNNaNNaNNaNSDENNNaNNaNNaNDE - GermanyDE - Germany1